Stored Procedures [dbo].[BAEErrorInsert]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@ErrorIDint4
@StackTracevarchar(255)255
@FriendlyErrorMessagevarchar(255)255
@ErrorTypevarchar(255)255
@ErrorDatedatetime8
@HttpRefervarchar(255)255
@HttpPathvarchar(255)255
@HttpHostvarchar(255)255
@HttpAllvarchar(255)255
@UserIDvarchar(255)255
@CookieDatavarchar(255)255
SQL Script
create procedure [dbo].[BAEErrorInsert] @ErrorID as
int,
    @StackTrace     AS     varchar(255),
    @FriendlyErrorMessage    AS    varchar(255),
    @ErrorType    AS    varchar(255),
    @ErrorDate    AS    datetime,
    @HttpRefer    AS    varchar(255),
    @HttpPath    AS    varchar(255),
    @HttpHost    AS    varchar(255),
    @HttpAll    AS    varchar(255),
    @UserID    AS    varchar(255),
    @CookieData    AS    varchar(255)
AS
    INSERT INTO Error
    (    
    StackTrace,
    FriendlyErrorMessage,
    ErrorType,
    ErrorDate,
    HttpRefer,
    HttpPath,
    HttpHost,
    HttpAll,
    UserID,
    CookieData
    )
    VALUES
    (    
    @StackTrace,
    @FriendlyErrorMessage,
    @ErrorType,
    @ErrorDate,
    @HttpRefer,
    @HttpPath,
    @HttpHost,
    @HttpAll,
    @UserID,
    @CookieData
    );

GO
Uses